--------------------------------------------------------
--  DDL for Table ACCOUNT
--------------------------------------------------------

  CREATE TABLE "ACCOUNT" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"USER_NAME" VARCHAR2(128 BYTE), 
	"PASSWORD" VARCHAR2(128 BYTE), 
	"ACTIVE" VARCHAR2(1 BYTE), 
	"GROUP_ID" VARCHAR2(36 BYTE), 
	"CREATE_DATE" DATE, 
	"UPDATE_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Index APP_USER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "APP_USER_PK" ON "ACCOUNT" ("APPLICATION_KEY", "USER_NAME")  ;
--------------------------------------------------------
--  Constraints for Table ACCOUNT
--------------------------------------------------------

  ALTER TABLE "ACCOUNT" ADD CONSTRAINT "APP_USER_PK" PRIMARY KEY ("APPLICATION_KEY", "USER_NAME");
  ALTER TABLE "ACCOUNT" MODIFY ("CREATE_DATE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT" MODIFY ("ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT" MODIFY ("PASSWORD" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT" MODIFY ("USER_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT" MODIFY ("APPLICATION_KEY" NOT NULL ENABLE);
